Ryan Sides
Ryan Sides
-
Re: I want a formula that specifies the lowest child of an ancestor, parent, child hierarchy.
Hi there! you can use the Descendants formula for that. Just add another column for it. =COUNT(DESCENDANTS([Hier Level]@row)) Then include when descendants column = 0 in your COUNTIFS formula.1 · -
Re: April Question of the Month - Join the conversation and receive a badge
Predictive resource management based on skill sets and availability Assist with user onboarding on to our specific instance of SS. “Go here for blank” “need to x? Do that here” etc. Generate user doc…1 · -
Re: Possible to copy data to cell if only one of multiple columns contain information
When you say "range" do you mean an actual range or do you mean you want every row of Column D to look at the same row to get the info? If the latter, then use a nested if statement and NOT…2 · -
Re: Displaying Most Current Info
Hi @LaBeach , if what you're considering as a "duplicate" is the person's Full Name, you can use the following formula which includes both MAX and COLLECT to gather the latest Submission Da…1 · -
Re: Select specific person/email as the name for automated alerts
Hey @bradrtn I created a solution that would do just that because we were emailing external customers from Smartsheet and it was causing confusion. You can include attachments as actual attachments i…1 ·
